[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
FT_ACCTQTR()
Return accounting quarter data
------------------------------------------------------------------------------
Syntax
FT_ACCTQTR( [ <dGivenDate> ], [ <nQtrNum> ] ) -> aDateinfo
Arguments
<dGivenDate> is any valid date in any date format. Defaults
to current system date if not supplied.
<nQtrNum> is a number from 1 to 4 signifying a quarter.
Defaults to current quarter if not supplied.
Returns
A three element array containing the following data:
aDateInfo[1] - The year and qtr. as a character string "YYYYQQ"
aDateInfo[2] - The beginning date of the accounting quarter
aDateInfo[3] - The ending date of the accounting quarter
Description
FT_ACCTQTR() creates an array containing data about the
accounting quarter containing the given date.
An accounting period has the following characteristics:
If the first week of the period contains 4 or more 'work'
days, it is included in the period; otherwise, the first
week was included in the prior period.
If the last week of the period contains 4 or more 'work'
days it is included in the period; otherwise, the last week
is included in the next period. This results in 13 week
'quarters' and 4 or 5 week 'months'. Every 5 or 6 years, a
'quarter' will contain 14 weeks and the year will contain 53
weeks.
Examples
// get info about accounting month containing 9/15/90
aDateInfo := FT_ACCTQTR( CTOD("09/15/90") )
? aDateInfo[1] // 199003 (3rd quarter)
? aDateInfo[2] // 07/01/90 beginning of quarter 3
? aDateInfo[3] // 09/29/90 end of quarter 3
// get info about accounting qtr. 2 in year containing 9/15/90
aDateInfo := FT_ACCTQTR( CTOD("09/15/90"), 2 )
? aDateInfo[1] // 199002
? aDateInfo[2] // 04/01/89 beginning of quarter 2
? aDateInfo[3] // 06/30/90 end of quarter 2
Source: ACCTQTR.PRG
Author: Jo W. French dba Practical Computing
See Also:
FT_DATECNFG()
FT_ACCTWEEK()
FT_ACCTMONTH()
FT_ACCTYEAR()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson